package com.suncaper.han_yi_system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.suncaper.han_yi_system.pojo.dto.ApplicationQueryDto;
import com.suncaper.han_yi_system.pojo.entity.SizeRecommendation;
import com.suncaper.han_yi_system.pojo.vo.SizeVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface SizeRecommendationMapper extends BaseMapper<SizeRecommendation> {

    List<SizeRecommendation> selectByStyleId(@Param("styleId") Long styleId);

    void deleteByStyleId(Long id);

    List<SizeVo> findCountByStyleId(@Param("styleId") Long styleId,
                                    @Param("collegeId") Long collegeId,
                                    @Param("academicYear") Integer academicYear);
}
